create view v_aph300_ph_day_his
AS 
select `sunsun_xiaoli`.`sunsun_aph300_ph_hour_his`.`did` AS `did`,avg(`sunsun_xiaoli`.`sunsun_aph300_ph_hour_his`.`ph`) AS `avg_ph`,`sunsun_xiaoli`.`sunsun_aph300_ph_hour_his`.`ymd` AS `his_date` from `sunsun_xiaoli`.`sunsun_aph300_ph_hour_his` group by `sunsun_xiaoli`.`sunsun_aph300_ph_hour_his`.`did`,`sunsun_xiaoli`.`sunsun_aph300_ph_hour_his`.`ymd`